| |
|
|
|
This ASP.NET server control creates a spreadsheet grid and enables formulas, numbers, text, labels and dates in cells. Use in financial calculators or anywhere else a spreadsheet template is used...albeit in a web page!
FAQ
What functions are supported (Sum(),Year(), etc.)?
All functionality from the .NET System.dll framework are supported. For example:
Basic math: [c0r0]+[c0r1]
System.Math namespace: Math.Pow(1+[c1r7],2)
Strings: `[c0r1]`.Trim().Replace(`$`,``).Substring(0,1)
Dates: DateTime d=new DateTime([c1r0]);return d.Year;
Formula cell references such as `[c0r1]` are replaced by the value of the cell, then evaluated. (Note that the value of a date cell is the number of ticks.) So the above examples might look like this before being evaluated:
Basic math: 100+200
System.Math namespace: Math.Pow(1+.045,2)
Strings: `$57`.Trim().Replace(`$`,``).Substring(0,1)
Dates:DateTime d=new DateTime(632272996777884556);return d.Year;
Formula cells are created like this:
Spread1.AddCell(new FormulaCell(1,6,`[c1r4]*[c2r6]`,`Formula`,NumericFormats.ToTheDollar));
See below for more examples of how formula cells work. Note also that there are two kinds of formulas, simple and multiline. The example below shows both types of formulas.
Code used in this example
Initialization of a spreadsheet
Using Mayersoft.Web.Controls;
private void Page_Init(object sender, System.EventArgs e)
{
Spread1.LicenseKey=`eL!NJ@2H3aF`;//sample key
}
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
Spread1.Columns.Add(new Column(150));
Spread1.Columns.Add(new Column());
Spread1.AddCell(new Cell(0,0,`Item 1`,`Label`));
Spread1.AddCell(new Cell(0,1,`Item 2`,`Label`));
Spread1.AddCell(new Cell(0,2,`Total`,`Label`));
Spread1.AddCell(new Cell(0,3,`Div by pct`,`Label`));
Spread1.AddCell(new Cell(0,4,`Result`,`Label`));
Spread1.AddCell(new Cell(0,5,`Price |
| « read more about MayerSoft.Web.Controls.Spreadsheet 1.0 |
|
|
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » DDLConnect 1.7.1
|
| DDLConnect.dll - allows the Windows CE eVB programmer to control dial-up (RAS) connections and perform reliable socket operations with ease. Methods included : DialASync - Dials any entry in the CE RAS phonebook returns immediately DialSync - Dials ... |
|
| Databasedevelopments.com | 0 | Win CE / Pocket PC | 0 | Downloads: 1455 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » CommAnalyzer seriell - serial Monitor 1.5
|
| In the new version 1.5 we support 32 ports and USB over serial port. The terminal program can work in principle either with or with two of different serial haven at the same time. In the following this haven with A and B are designated. Three possible o ... |
|
| E-furt.de | 0 | Win 3.1/95/NT/2000/XP/98/ME | E37 | Downloads: 1401 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| 4gl.fr | 0 | Win 95/NT/2000/XP/98/ME | E605 | Downloads: 1314 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » AppbarXtra 1.0
|
| Develop desktop toolbars (so called appbars) for Windows 9x, NT, Windows 2000 and XP with Director and the new AppbarXtra. A variety of exciting applications becomes possible. Newstickers that collect topical information and deliver it right onto the desk ... |
|
| Score.de | 0 | Win 95/NT/2000/XP/98/ME | $50 | Downloads: 1425 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » GoldLimit Hickwall 1.0
|
| What is Hickwall? It is a professional software debugger ,security verifying program. A:Professional software debugger: Hickwall is a kind of professional software debugger ,if you have it,you can make it easy to control the inner part of the appli ... |
|
| Goldlimit.com | 0 | Win 95/NT/2000/98/ME | $35 | Downloads: 1449 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Kgroup PixFont 3.2
|
| PixFont help you to solve font-antialiasing problem in Flash. PixFont is very simple in using. Our site has complete instructions for using pixel font in Flash. www.kgroup.ru/articles/pixfont.html ... |
|
| Kgroup.ru | 0 | Win 95/NT/2000/XP/98/ME | $29 | Downloads: 1317 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Easy-Submitter 1.0
|
| This tool helps shareware developers to submit there program information to all the software archives. The program supports PAD files. It works with all archives and is not limited on a number of archives. You have to fill out the form fields of a submit ... |
|
| Cadkas.de | 0 | Win 95/NT/2000/XP/98/ME | $49 | Downloads: 1313 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| Airetec.com | 0 | Win 95Win CE / Pocket PC /NT/2 | E450 | Downloads: 1356 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Boolnet Easy Pie Chart 1.0 1.0
|
| Boolnet Easy Pie Chart 1.0 Boolnet Easy Pie Chart 1.0 will improve your web project whenever you need an elegant presentation with minimum work. To install you just need to drop the application file to the web executable directory and start using. A ... |
|
| Boolnet.com | 0 | Win NT/2000 | $19.99 | Downloads: 1384 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| Airetec.com | 0 | Win 95Win CE / Pocket PC /NT/2 | E450 | Downloads: 1344 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » VLFullScreen Ver 1.0 (Four Developers Pack) 1.0
|
| VLFullScreen allows your application to acquire all of the available screen area as and when desired with absolutely minimal coding (how about zero !). Complete control on the font and text lets you use it for applications developed for non-English lan ... |
|
| Viklele.com | 0 | Win 95/NT/2000/XP/98/ME | $74.75 | Downloads: 1300 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Boolnet Easy Bar Chart 1.0 1.0
|
| Boolnet Easy Bar Chart 1.0 Boolnet Easy Bar Chart 1.0 will improve your web project whenever you need an elegant presentation with minimum work. To install you just need to drop the application file to the web executable directory and start using. A ... |
|
| Boolnet.com | 0 | Win NT/2000 | $19.99 | Downloads: 1404 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Boolnet Easy Chart Pack 1.0 1.0
|
| Boolnet Easy Chart Pack 1.0 Boolnet Easy Chart Pack 1.0 contains the powerful components Easy Pie Chart 1.0 and Easy Bar Chart 1.0. This applications will improve your web project whenever you need an elegant presentation with minimum work. To install ... |
|
| Boolnet.com | 0 | Win NT/2000 | $29.99 | Downloads: 1451 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| |
| Obsidium.de | 0 | Win 95/NT/2000/XP/98/ME | $59 | Downloads: 1431 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Search32 v.6x - 5 copies v.6x
|
| Search32 is a program for searching in a large number of text files stored on personal computer or in local area network. Provides very fast search using preliminary created index files. This new vesion contains functions opened for developers, who want t ... |
|
| Anetsoft.com | 0 | Win 95/NT/2000/XP/98/ME | $150 | Downloads: 1463 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - Windows (download) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Win 95/NT/2000/XP/98/ME | $425 | Downloads: 1367 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - Windows (CD Box) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Win 95/NT/2000/XP/98/ME | $495 | Downloads: 1316 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - MacOS (download) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Macintosh | $425 | Downloads: 1385 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Mathematica Link for LabVIEW - MacOS (CD Box) 2.0
|
| Mathematica Link for LabVIEW opens up a world of new possibilities for engineers, technicians, researchers, and post-secondary educators. Leveraging the symbolic and mathematical power of one of the world`s most sophisticated mathematics package --M ... |
|
| Bettervi.com | 0 | Macintosh | $495 | Downloads: 1325 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » .NET Memory Profiler 1.0
|
| .NET Memory Profiler is a tool for the .NET Common Language Runtime that allows the user to track all instances that are allocated on the garbage collected heap (GC heap). The user can collect snapshots of the GC heap and get information about the instan ... |
|
| Scitech.se | 0 | Win 2000/XP | $65 | Downloads: 1588 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
